15 12월

mariadb-10.3 : enum empty insert error Hint : STRICT_TRANS_TABLES

mysql -uroot -p -e "show variables like 'sql_mode';"

sql_mode  = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

 

remove STRICT_TRANS_TABLES

 

mysql -uroot -p -e "SET GLOBAL sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';"

 

by